﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Zor_Modes;
using Zor_IDAL;
using Zor_Tools;

namespace Zor_DAL
{
    public class HouseRental_DAL<T> where T : class
    {
        /// <summary>
        /// 获取租赁管理列表（不分页）
        /// create 刘云飞 by 2017/04/06   
        /// </summary>
        /// <returns></returns>
        public static List<T> SelectViewHouseRental(string where = null)
        {
            string strwhere = "";
            if (!string.IsNullOrEmpty(where))
            {
                strwhere = "1=1 and " + where;
            }
            var sql = "select * from V_HouseRental where " + strwhere + "order by Lease_Id ";
            return DapperQuery<T>.DoQueryList(sql, null);
        }
    }
}
